﻿SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
GO
ALTER TABLE BLOG_SETTINGS ADD CONSTRAINT
	DF_BLOG_SETTINGS_viewfactory DEFAULT 1 FOR viewfactory
GO
ALTER TABLE BLOG_SETTINGS ADD CONSTRAINT
	DF_BLOG_SETTINGS_postlistmodel DEFAULT 1 FOR postlistmodel
GO
ALTER TABLE BLOG_SETTINGS ADD CONSTRAINT
	DF_BLOG_SETTINGS_postmodel DEFAULT 1 FOR postmodel
GO
ALTER TABLE BLOG_SETTINGS SET (LOCK_ESCALATION = TABLE)
GO
UPDATE
	BLOG_SETTINGS
SET
	viewfactory = 1,
	postlistmodel = 1,
	postmodel = 1
GO
ALTER TABLE BLOG_SETTINGS ALTER COLUMN viewfactory INT NOT NULL
GO
ALTER TABLE BLOG_SETTINGS ALTER COLUMN postlistmodel INT NOT NULL
GO
ALTER TABLE BLOG_SETTINGS ALTER COLUMN postmodel INT NOT NULL
